UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GZJE7SgT1jfKr4LUHR898CEdDn1C5fc9fLHeGCYzP/w='
WHERE
key_id = 'ac86289abd014f71f2102d981cbd1a80aedf99fb9f0b5f3c727170d025fbfec0'
AND (
token = 'GZJE7SgT1jfKr4LUHR898CEdDn1C5fc9fLHeGCYzP/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)