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