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