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