UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U9hlQ4XAxm5lUEefSmjzAl21sXIbLycE17EL5SF+qpU='
WHERE
key_id = '311cc3c10364abaaa0d5be76153dda0c5ae89f05d70110631a25dca4d39a67e2'
AND (
token = 'U9hlQ4XAxm5lUEefSmjzAl21sXIbLycE17EL5SF+qpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)