UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '92D0Isz16cRF9PE87Op+fxZ+P4umVNAWsimNOzgFuZ8=' 
WHERE 
  key_id = '6938c0a0352c3d504704eb2acfb4bea3d18a223db8c8c5235d9ae5df6d9d6099' 
  AND (
    token = '92D0Isz16cRF9PE87Op+fxZ+P4umVNAWsimNOzgFuZ8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033