UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G6uU/pVailqz3XXqjTgk7hc6swx7Sc/wUXUKc0I9Ils='
WHERE
key_id = 'e8a01b70adf70dedef436b7fb33279304f11a17d04a9dcc093aa9f1530a05e9f'
AND (
token = 'G6uU/pVailqz3XXqjTgk7hc6swx7Sc/wUXUKc0I9Ils='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)