UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g3+YeZHCxDejrvmhDiA//3Q3j4ynUBhb07xWaBi6Kfg='
WHERE
key_id = '9f8ecc7aff123d6497348dd0d61cd7312c66a11b7967e5c70449ffec3cbf6748'
AND (
token = 'g3+YeZHCxDejrvmhDiA//3Q3j4ynUBhb07xWaBi6Kfg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)