UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6N8+dE75UdJE1e+6NK0OPGJrtrA1rHqIwq0Q7qBRQvs='
WHERE
key_id = 'e5b7d2bf60d39d58ea55e3e050860f22186a27f70d2547cde9d45fc49d7a6d21'
AND (
token = '6N8+dE75UdJE1e+6NK0OPGJrtrA1rHqIwq0Q7qBRQvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)