UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JB1SjolCFF+RuW9G8WXX/eoBk64BkSltZhTG4U9OmPU='
WHERE
key_id = '0cc42899e02f78f87a0698f550a0e2420f6fd1abdd5a0ea6119a9e782ac1a91f'
AND (
token = 'JB1SjolCFF+RuW9G8WXX/eoBk64BkSltZhTG4U9OmPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)