UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rLGhBomGDqLCzNzVNBZUUN1N6vkghp1ez5gYnuNxxV8='
WHERE
key_id = '501aead9294007268670a4abda4f87820eddce2a8203f6737af5def65284381d'
AND (
token = 'rLGhBomGDqLCzNzVNBZUUN1N6vkghp1ez5gYnuNxxV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)