UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SZc4hxeKMvwxsgznaRY5Mxt540m7pDsL4RNtF0idX80='
WHERE
key_id = '8f5069ebee0047c0a5c52fc4e33a7dc42143e8bf2150484900a7a026a9cb3f15'
AND (
token = 'SZc4hxeKMvwxsgznaRY5Mxt540m7pDsL4RNtF0idX80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)