UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N1XxcW0O0PxeDUXGnTFiCpAFf3aeU9h8xX8CT7s8+LA='
WHERE
key_id = '9a3835545cc1c862015ce15452f2863f44fc42628c5c3440bcecaf2bf8f618b4'
AND (
token = 'N1XxcW0O0PxeDUXGnTFiCpAFf3aeU9h8xX8CT7s8+LA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)