UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4lS3bDVZ1L2XqzreLM4ObbPIgEz1pXhkrEGDhkETda4='
WHERE
key_id = '79c2fb6b466cf82060112571174c89e9913b7662c7a019b486c64e3aa098bc9a'
AND (
token = '4lS3bDVZ1L2XqzreLM4ObbPIgEz1pXhkrEGDhkETda4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)