UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '56Tcpm7Nia4EkOwtgR932qRTWIi2bL0lMMN6tqfAa+E='
WHERE
key_id = '6167d879e9c911cfab89fa57e24580eb9ff9bfedf826048cb80228f60b55ff6e'
AND (
token = '56Tcpm7Nia4EkOwtgR932qRTWIi2bL0lMMN6tqfAa+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)