UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8mEwO/nuHs3cILCGiT8gLRIfkMro9pD0ABMCU0GHt6o='
WHERE
key_id = '6f87495d282bca6b6c6ab8154736d4111dd562977b64c71721e29e9f77e72aac'
AND (
token = '8mEwO/nuHs3cILCGiT8gLRIfkMro9pD0ABMCU0GHt6o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)