UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5jOeDP73kW9AuwM/elr+j2OUujIsfrNXhJQ9l2Eu5P4='
WHERE
key_id = '31381fa6e0cec09138d16f175272614ae7a99153de8657b9022a02b1d98eccc5'
AND (
token = '5jOeDP73kW9AuwM/elr+j2OUujIsfrNXhJQ9l2Eu5P4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)