UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HU7s0yArQkbLI0ClYmoa2xIDYLwus3e7ofzoIcwOzgk='
WHERE
key_id = 'c241a89189acf88e08c7d94b69a87f4572013a6253f69abec9f34917c99d842f'
AND (
token = 'HU7s0yArQkbLI0ClYmoa2xIDYLwus3e7ofzoIcwOzgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)