UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nbJ/Z+JsgJKN/uBJ78hkcRibOHKAte8989Kkydf83gA='
WHERE
key_id = 'c8dd26d8464e45a31181a7f540f079d318dad37cae54f0a134664e1daa73a3b7'
AND (
token = 'nbJ/Z+JsgJKN/uBJ78hkcRibOHKAte8989Kkydf83gA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)