UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aP9N9TWcRJa+y80bNwBxuJBnUpI24p2DPC2EB0bDAso='
WHERE
key_id = 'f6f29e2bf208f0194177e1511748afcb24ae704c1b0798cfc569301ac3745910'
AND (
token = 'aP9N9TWcRJa+y80bNwBxuJBnUpI24p2DPC2EB0bDAso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)