UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2JnpZfb/0AfF6eq6aZ7DbceN9glkdQz81r26pFryvv0='
WHERE
key_id = 'c23ab56323c0262879fbf7b76882a76ab801270639bf228b75fe207b7ec9427f'
AND (
token = '2JnpZfb/0AfF6eq6aZ7DbceN9glkdQz81r26pFryvv0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)