UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vPZV2ntGTh9Aq2Y5elaVAZ2sa0eSPfB/1WJIQJW8/Yo='
WHERE
key_id = 'd80e7b109959df966220160f0a1b86e09cde901f4499364563e73720db26b109'
AND (
token = 'vPZV2ntGTh9Aq2Y5elaVAZ2sa0eSPfB/1WJIQJW8/Yo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)