UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WY7LJvkekh79ha2msUR1x9UZ1cM75MYITa5qij5yRsM='
WHERE
key_id = 'aa4c181aa75a59f93f403cb519671a9c2a982116fb7b26408671dbe345b6571a'
AND (
token = 'WY7LJvkekh79ha2msUR1x9UZ1cM75MYITa5qij5yRsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)