UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hpqt+HVk5BZ3MFNDDOSeze4fSVng5p8kxZ3vBdll/+4='
WHERE
key_id = '6b9a75e68fe5ee1f8bbcd3fcda89569d7e48dfd338a383cff5cc7a12a86f9249'
AND (
token = 'Hpqt+HVk5BZ3MFNDDOSeze4fSVng5p8kxZ3vBdll/+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)