UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z/hR0DFHLjaF+mautzvuiSKoeZ64+eNq09n5TG64cfY='
WHERE
key_id = '509e0e1f43a22bf42e41fc96157fbc035a02612938b0ebc246c798a6e3e9ab10'
AND (
token = 'z/hR0DFHLjaF+mautzvuiSKoeZ64+eNq09n5TG64cfY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)