UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cG/y2eoYKfmldjfVz40etiURsCLZzRsOhY8hpyJLDx0='
WHERE
key_id = 'f20edc76ddc48e1d0a6d2503daa44850ef412faa94dfdc6369ab94e52fb1fc45'
AND (
token = 'cG/y2eoYKfmldjfVz40etiURsCLZzRsOhY8hpyJLDx0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)