UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qO332RW1K0BvpzkDHb77Gx6PDWzlhajV0As0EnpG6nk='
WHERE
key_id = 'f66bbd57971563cceda2cc2a3c7162cf27c97b67b4c1f858af0e8b167aafed79'
AND (
token = 'qO332RW1K0BvpzkDHb77Gx6PDWzlhajV0As0EnpG6nk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)