UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OEPWcXUg+ykLM7ci8JBTeNpD0Bv3O6VTTADSfW7DMA8='
WHERE
key_id = 'a0fc291f0f68ad43f906e4cd72bc18a4885b1a14ecfd8452197b0a6054b59cf9'
AND (
token = 'OEPWcXUg+ykLM7ci8JBTeNpD0Bv3O6VTTADSfW7DMA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)