UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MSnmk41KEx0aIFQgoDhVhialaoQ1NfLj6+z3nkU6+Zs='
WHERE
key_id = '717fb6d6e4c25740bf5b480e74ea940c7f6f23b2c284c199d2388ff2f642ad4b'
AND (
token = 'MSnmk41KEx0aIFQgoDhVhialaoQ1NfLj6+z3nkU6+Zs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)