UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jg2mKrKrVyDXv38h1I47NYVVGUge28/QfXsD1p/snwQ='
WHERE
key_id = 'fc386dfa8306de3278a7d9e18a5b0f5d4af507e5f3def0ef567bc877703b16a5'
AND (
token = 'Jg2mKrKrVyDXv38h1I47NYVVGUge28/QfXsD1p/snwQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)