UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1u6Fp/3nYEZRRG7avLc/QBVdKIdq3jNJaLjvt3P8eEQ='
WHERE
key_id = 'a9d117a47e1b6b6304bbc780ddb403d0ec11031842f204e1868e1497be64fb7d'
AND (
token = '1u6Fp/3nYEZRRG7avLc/QBVdKIdq3jNJaLjvt3P8eEQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)