UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1xMXZeLnKGiJyNFS0IrFOG1vTzMU5Nm0SQ6RAYnfKYY='
WHERE
key_id = 'efff159754d447c721011ec94f37ad6825b1f4d16cd003ea3d6494627400e211'
AND (
token = '1xMXZeLnKGiJyNFS0IrFOG1vTzMU5Nm0SQ6RAYnfKYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)