UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uOpdDKkj4/DMyqI6X/qgHkw+KgaYr1Bktsssp85s5XA='
WHERE
key_id = 'e402dc2001fae3006c23894f7fa507a48e35bf20a394884e90311a4d2a313d2a'
AND (
token = 'uOpdDKkj4/DMyqI6X/qgHkw+KgaYr1Bktsssp85s5XA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)